LNR-server-02-cascading-failure-scenario-simulatio

import json import pandas as pd import geopandas as gpd from shapely.geometry import Point, LineString def convert_CSVfile_to_JSONfile(json_input_path: str) -> str: json_input_path = json_input_path.strip().replace('"', '') with open(json_input_path, 'r') as file: data = json.load(file) infrastructure_information = data['infrastructure_information'] with open(infrastructure_information, 'r') as file: data = json.load(file) network_files = data['network_csv_files'] all_network_data = {'nodes': [], 'edges': []} for network in network_files: points_file = network['points'] lines_file = network['lines'] # Read points CSV points_df = pd.read_csv(points_file) # Create geometry Points from coordinate columns (assuming 'X' and 'Y' or 'Longitude' and 'Latitude') points_df['geometry'] = points_df.apply(lambda row: Point(row['X'], row['Y']), axis=1) points_df['node_properties'] = points_df.apply( lambda row: {'Code': row['Code'], 'Facility': row['Facility'], 'Service Area': row['SA'], 'Location': row['location'], 'Demands': row['Demands'], 'Coordinates': [row['X'], row['Y']], 'Infrastructure Type': row['IT']}, axis=1) # Read lines CSV lines_df = pd.read_csv(lines_file) # Assuming lines CSV has start and end node coordinates or IDs — here we just pass attributes lines_df['edge_properties'] = lines_df.apply( lambda row: {'Code': row['Code'], 'Start': row['Start_node'], 'End': row['End_node'], 'Infrastructure Type': row['IT']}, axis=1) all_network_data['nodes'].extend(points_df['node_properties'].tolist()) all_network_data['edges'].extend(lines_df['edge_properties'].tolist()) output_json_path = 'infrastructure_networks.json' with open(output_json_path, 'w') as outfile: json.dump(all_network_data, outfile, indent=4) # Update global JSON with open(json_input_path, 'r') as file: global_data = json.load(file) global_data['infrastructure_networks'] = output_json_path with open(json_input_path, 'w') as file: json.dump(global_data, file, indent=4) return "The path to infrastructure_networks has been saved in Global_data.json"